package com.vastcom.sigma.admin.dao;


import com.vastcom.sigma.admin.model.Cuptest;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface CuptestDao extends JpaRepository<Cuptest,String> {

    @Query("select c from Cuptest c where c.clqk=:cargocateid ")
    List<Cuptest> getCuptestsByClqk(@Param("cargocateid") String cargocateid);

    @Query("select c from Cuptest c where c.scpcid=:scpc ")
    List<Cuptest> getCuptestsByScpc(@Param("scpc") String scpc);

}
